package com.pipi.sso.dao.query;


import com.pipi.sso.dao.support.BaseCriteria;
import com.pipi.sso.dao.support.BaseQuery;
import org.apache.commons.lang.builder.ReflectionToStringBuilder;
import org.apache.commons.lang.builder.ToStringStyle;

import java.io.Serializable;

import java.util.Date;
import java.util.List;

public class DormitoryAssetsQuery extends BaseQuery implements Serializable {
    private static final long serialVersionUID = 1L;

    public DormitoryAssetsQuery() {
        super();
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        super.oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * This class corresponds to the database table dorm_dormitory_assets
     */
         protected abstract static class GeneratedCriteria extends BaseCriteria {

        protected GeneratedCriteria() {
            super();
        }

        public Criteria andDormitoryAssetsIdIsNull() {
            addCriterion("dormitory_assets_id is null");
            return (Criteria) this;
        }

        public Criteria andDormitoryAssetsIdIsNotNull() {
            addCriterion("dormitory_assets_id is not null");
            return (Criteria) this;
        }

        public Criteria andDormitoryAssetsIdEqualTo(Long value) {
            addCriterion("dormitory_assets_id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andDormitoryAssetsIdNotEqualTo(Long value) {
            addCriterion("dormitory_assets_id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria anDormitoryAssetsIdGreaterThan(Long value) {
            addCriterion("dormitory_assets_id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andDormitoryAssetsIdGreaterThanOrEqualTo(Long value) {
            addCriterion("dormitory_assets_id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andDormitoryAssetsIdLessThan(Long value) {
            addCriterion("dormitory_assets_id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andDormitoryAssetsIdLessThanOrEqualTo(Long value) {
            addCriterion("dormitory_assets_id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andDormitoryAssetsIdIn(List<Long> values) {
            addCriterion("dormitory_assets_id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andDormitoryAssetsIdNotIn(List<Long> values) {
            addCriterion("dormitory_assets_id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andDormitoryAssetsIdBetween(Long value1, Long value2) {
            addCriterion("dormitory_assets_id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andDormitoryAssetsIdNotBetween(Long value1, Long value2) {
            addCriterion("dormitory_assets_id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNull() {
            addCriterion("gmt_create is null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNotNull() {
            addCriterion("gmt_create is not null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateEqualTo(Date value) {
            addCriterion("gmt_create =", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotEqualTo(Date value) {
            addCriterion("gmt_create <>", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThan(Date value) {
            addCriterion("gmt_create >", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThanOrEqualTo(Date value) {
            addCriterion("gmt_create >=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThan(Date value) {
            addCriterion("gmt_create <", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThanOrEqualTo(Date value) {
            addCriterion("gmt_create <=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIn(List<Date> values) {
            addCriterion("gmt_create in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotIn(List<Date> values) {
            addCriterion("gmt_create not in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateBetween(Date value1, Date value2) {
            addCriterion("gmt_create between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotBetween(Date value1, Date value2) {
            addCriterion("gmt_create not between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNull() {
            addCriterion("gmt_modified is null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNotNull() {
            addCriterion("gmt_modified is not null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedEqualTo(Date value) {
            addCriterion("gmt_modified =", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotEqualTo(Date value) {
            addCriterion("gmt_modified <>", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThan(Date value) {
            addCriterion("gmt_modified >", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThanOrEqualTo(Date value) {
            addCriterion("gmt_modified >=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThan(Date value) {
            addCriterion("gmt_modified <", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThanOrEqualTo(Date value) {
            addCriterion("gmt_modified <=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIn(List<Date> values) {
            addCriterion("gmt_modified in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotIn(List<Date> values) {
            addCriterion("gmt_modified not in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedBetween(Date value1, Date value2) {
            addCriterion("gmt_modified between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotBetween(Date value1, Date value2) {
            addCriterion("gmt_modified not between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomIdIsNull() {
            addCriterion("dormitory_room_id is null");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomIdIsNotNull() {
            addCriterion("dormitory_room_id is not null");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomIdEqualTo(Long value) {
            addCriterion("dormitory_room_id =", value, "dormitoryRoomId");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomIdNotEqualTo(Long value) {
            addCriterion("dormitory_room_id <>", value, "dormitoryRoomId");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomIdGreaterThan(Long value) {
            addCriterion("dormitory_room_id >", value, "dormitoryRoomId");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomIdGreaterThanOrEqualTo(Long value) {
            addCriterion("dormitory_room_id >=", value, "dormitoryRoomId");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomIdLessThan(Long value) {
            addCriterion("dormitory_room_id <", value, "dormitoryRoomId");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomIdLessThanOrEqualTo(Long value) {
            addCriterion("dormitory_room_id <=", value, "dormitoryRoomId");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomIdLike(Long value) {
            addCriterion("dormitory_room_id like", value, "dormitoryRoomId");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomIdNotLike(Long value) {
            addCriterion("dormitory_room_id not like", value, "dormitoryRoomId");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomIdIn(List<Long> values) {
            addCriterion("dormitory_room_id in", values, "dormitoryRoomId");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomIdNotIn(List<Long> values) {
            addCriterion("dormitory_room_id not in", values, "dormitoryRoomId");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomIdBetween(Long value1, Long value2) {
            addCriterion("dormitory_room_id between", value1, value2, "dormitoryRoomId");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomIdNotBetween(Long value1, Long value2) {
            addCriterion("dormitory_room_id not between", value1, value2, "dormitoryRoomId");
            return (Criteria) this;
        }

        public Criteria andDormitoryLayerNoIsNull() {
            addCriterion("dormitory_layer_no is null");
            return (Criteria) this;
        }

        public Criteria andDormitoryLayerNoIsNotNull() {
            addCriterion("dormitory_layer_no is not null");
            return (Criteria) this;
        }

        public Criteria andDormitoryLayerNoEqualTo(Integer value) {
            addCriterion("dormitory_layer_no =", value, "dormitoryLayerNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryLayerNoNotEqualTo(Integer value) {
            addCriterion("dormitory_layer_no <>", value, "dormitoryLayerNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryLayerNoGreaterThan(Integer value) {
            addCriterion("dormitory_layer_no >", value, "dormitoryLayerNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryLayerNoGreaterThanOrEqualTo(Integer value) {
            addCriterion("dormitory_layer_no >=", value, "dormitoryLayerNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryLayerNoLessThan(Integer value) {
            addCriterion("dormitory_layer_no <", value, "dormitoryLayerNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryLayerNoLessThanOrEqualTo(Integer value) {
            addCriterion("dormitory_layer_no <=", value, "dormitoryLayerNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryLayerNoLike(Integer value) {
            addCriterion("dormitory_layer_no like", value, "dormitoryLayerNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryLayerNoNotLike(Integer value) {
            addCriterion("dormitory_layer_no not like", value, "dormitoryLayerNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryLayerNoIn(List<Integer> values) {
            addCriterion("dormitory_layer_no in", values, "dormitoryLayerNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryLayerNoNotIn(List<Integer> values) {
            addCriterion("dormitory_layer_no not in", values, "dormitoryLayerNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryLayerNoBetween(Integer value1, Integer value2) {
            addCriterion("dormitory_layer_no between", value1, value2, "dormitoryLayerNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryLayerNoNotBetween(Integer value1, Integer value2) {
            addCriterion("dormitory_layer_no not between", value1, value2, "dormitoryLayerNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomNoIsNull() {
            addCriterion("dormitory_room_no is null");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomNoIsNotNull() {
            addCriterion("dormitory_room_no is not null");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomNoEqualTo(String value) {
            addCriterion("dormitory_room_no =", value, "dormitoryRoomNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomNoNotEqualTo(String value) {
            addCriterion("dormitory_room_no <>", value, "dormitoryRoomNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomNoGreaterThan(String value) {
            addCriterion("dormitory_room_no >", value, "dormitoryRoomNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomNoGreaterThanOrEqualTo(String value) {
            addCriterion("dormitory_room_no >=", value, "dormitoryRoomNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomNoLessThan(String value) {
            addCriterion("dormitory_room_no <", value, "dormitoryRoomNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomNoLessThanOrEqualTo(String value) {
            addCriterion("dormitory_room_no <=", value, "dormitoryRoomNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomNoLike(String value) {
            addCriterion("dormitory_room_no like", value, "dormitoryRoomNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomNoNotLike(String value) {
            addCriterion("dormitory_room_no not like", value, "dormitoryRoomNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomNoIn(List<String> values) {
            addCriterion("dormitory_room_no in", values, "dormitoryRoomNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomNoNotIn(List<String> values) {
            addCriterion("dormitory_room_no not in", values, "dormitoryRoomNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomNoBetween(String value1, String value2) {
            addCriterion("dormitory_room_no between", value1, value2, "dormitoryRoomNo");
            return (Criteria) this;
        }

        public Criteria andDormitoryRoomNoNotBetween(String value1, String value2) {
            addCriterion("dormitory_room_no not between", value1, value2, "dormitoryRoomNo");
            return (Criteria) this;
        }

        public Criteria andAssetsIdIsNull() {
            addCriterion("assets_id is null");
            return (Criteria) this;
        }

        public Criteria andAssetsIdIsNotNull() {
            addCriterion("assets_id is not null");
            return (Criteria) this;
        }

        public Criteria andAssetsIdEqualTo(Long value) {
            addCriterion("assets_id =", value, "assetsId");
            return (Criteria) this;
        }

        public Criteria andAssetsIdNotEqualTo(Long value) {
            addCriterion("assets_id <>", value, "assetsId");
            return (Criteria) this;
        }

        public Criteria andAssetsIdGreaterThan(Long value) {
            addCriterion("assets_id >", value, "assetsId");
            return (Criteria) this;
        }

        public Criteria andAssetsIdGreaterThanOrEqualTo(Long value) {
            addCriterion("assets_id >=", value, "assetsId");
            return (Criteria) this;
        }

        public Criteria andAssetsIdLessThan(Long value) {
            addCriterion("assets_id <", value, "assetsId");
            return (Criteria) this;
        }

        public Criteria andAssetsIdLessThanOrEqualTo(Long value) {
            addCriterion("assets_id <=", value, "assetsId");
            return (Criteria) this;
        }

        public Criteria andAssetsIdLike(Long value) {
            addCriterion("assets_id like", value, "assetsId");
            return (Criteria) this;
        }

        public Criteria andAssetsIdNotLike(Long value) {
            addCriterion("assets_id not like", value, "assetsId");
            return (Criteria) this;
        }

        public Criteria andAssetsIdIn(List<Long> values) {
            addCriterion("assets_id in", values, "assetsId");
            return (Criteria) this;
        }

        public Criteria andAssetsIdNotIn(List<Long> values) {
            addCriterion("assets_id not in", values, "assetsId");
            return (Criteria) this;
        }

        public Criteria andAssetsIdBetween(Long value1, Long value2) {
            addCriterion("assets_id between", value1, value2, "assetsId");
            return (Criteria) this;
        }

        public Criteria andAssetsIdNotBetween(Long value1, Long value2) {
            addCriterion("assets_id not between", value1, value2, "assetsId");
            return (Criteria) this;
        }

        public Criteria andAssetsNameIsNull() {
            addCriterion("assets_name is null");
            return (Criteria) this;
        }

        public Criteria andAssetsNameIsNotNull() {
            addCriterion("assets_name is not null");
            return (Criteria) this;
        }

        public Criteria andAssetsNameEqualTo(String value) {
            addCriterion("assets_name =", value, "assetsName");
            return (Criteria) this;
        }

        public Criteria andAssetsNameNotEqualTo(String value) {
            addCriterion("assets_name <>", value, "assetsName");
            return (Criteria) this;
        }

        public Criteria andAssetsNameGreaterThan(String value) {
            addCriterion("assets_name >", value, "assetsName");
            return (Criteria) this;
        }

        public Criteria andAssetsNameGreaterThanOrEqualTo(String value) {
            addCriterion("assets_name >=", value, "assetsName");
            return (Criteria) this;
        }

        public Criteria andAssetsNameLessThan(String value) {
            addCriterion("assets_name <", value, "assetsName");
            return (Criteria) this;
        }

        public Criteria andAssetsNameLessThanOrEqualTo(String value) {
            addCriterion("assets_name <=", value, "assetsName");
            return (Criteria) this;
        }

        public Criteria andAssetsNameLike(String value) {
            addCriterion("assets_name like", value, "assetsName");
            return (Criteria) this;
        }

        public Criteria andAssetsNameNotLike(String value) {
            addCriterion("assets_name not like", value, "assetsName");
            return (Criteria) this;
        }

        public Criteria andAssetsNameIn(List<String> values) {
            addCriterion("assets_name in", values, "assetsName");
            return (Criteria) this;
        }

        public Criteria andAssetsNameNotIn(List<String> values) {
            addCriterion("assets_name not in", values, "assetsName");
            return (Criteria) this;
        }

        public Criteria andAssetsNameBetween(String value1, String value2) {
            addCriterion("assets_name between", value1, value2, "assetsName");
            return (Criteria) this;
        }

        public Criteria andAssetsNameNotBetween(String value1, String value2) {
            addCriterion("assets_name not between", value1, value2, "assetsName");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIsNull() {
            addCriterion("is_deleted is null");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIsNotNull() {
            addCriterion("is_deleted is not null");
            return (Criteria) this;
        }

        public Criteria andIsDeletedEqualTo(Integer value) {
            addCriterion("is_deleted =", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotEqualTo(Integer value) {
            addCriterion("is_deleted <>", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedGreaterThan(Integer value) {
            addCriterion("is_deleted >", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_deleted >=", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLessThan(Integer value) {
            addCriterion("is_deleted <", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLessThanOrEqualTo(Integer value) {
            addCriterion("is_deleted <=", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLike(Integer value) {
            addCriterion("is_deleted like", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotLike(Integer value) {
            addCriterion("is_deleted not like", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIn(List<Integer> values) {
            addCriterion("is_deleted in", values, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotIn(List<Integer> values) {
            addCriterion("is_deleted not in", values, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedBetween(Integer value1, Integer value2) {
            addCriterion("is_deleted between", value1, value2, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotBetween(Integer value1, Integer value2) {
            addCriterion("is_deleted not between", value1, value2, "isDeleted");
            return (Criteria) this;
        }

    }

    /**
     * This class corresponds to the database table dorm_dormitory_assets
    */
    public  static class Criteria extends GeneratedCriteria{
        protected Criteria() {
            super();
        }
    }



    @Override
    public String toString(){
        return ReflectionToStringBuilder.toString(this, ToStringStyle.DEFAULT_STYLE);
    }
}